<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
    pageEncoding="ISO-8859-1"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>Login</title>
</head>
<body>
<%@ page import ="java.sql.*" %>
 <%@ page import ="javax.sql.*" %>
 <%
 String userid=request.getParameter("user"); 
 session.putValue("userid",userid); 
 String pwd=request.getParameter("pwd"); 
 Class.forName("com.mysql.jdbc.Driver"); 
 java.sql.Connection con = DriverManager.getConnection("jdbc:mysql://localhost/Library","root","1234"); 
 Statement st= con.createStatement(); 
 ResultSet rs=st.executeQuery("select * from person where login="+userid+""); 
  
 if(rs.getString(4).equals(pwd)) 
 { 
 out.println("welcome"+userid); 

 } 
 else 
 { 
 out.println("Invalid password try again"); 
 } 
  
 %>
</body>
</html>